package com.oracle.cmp.service;

import com.oracle.cmp.common.Result;
import com.oracle.cmp.entity.OrderDetail;
import com.oracle.jdbc.util.Dao;

import java.util.List;
import java.util.Map;

public class OredrDetailmpl implements OredrDetailService {
    @Override
    public Result queryForPage(Map<String, Object> map, int pageNum) {
        return null;
    }

    @Override
    public int count(Map<String, Object> map) {
        return 0;
    }

    @Override
    public  List<OrderDetail> queryOrdeId(int OrderId) {
       String sql="select r.*,partsname,p.PartsReqCount from biz_orderdetail r left outer join biz_parts b on r.partsid=b.partsid LEFT OUTER JOIN  biz_partsrepertory p ON  r.PartsId=p.PartsId where orderid=?";
       return  Dao.query(sql,OrderDetail.class,OrderId);
    }
}
